package com.yumeno.epidemic.mapper;

import com.yumeno.epidemic.beans.UserInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface UserMapper {

    @Select(value = "SELECT user_id,user_name,account,`password`  " +
            "FROM users  " +
            "WHERE account = #{account}  " +
            "AND (del_flag IS NULL  " +
            "OR del_flag=0)")
    UserInfo findByAccount(String account);
}
